<template>
  <div class="mod-config">
    <el-form :inline="true" :model="dataForm" @keyup.enter.native="getDataList()">
      <el-form-item>
        <el-input v-model="dataForm.name" placeholder="链接名称" clearable></el-input>
      </el-form-item>
      <el-form-item>
        <el-button @click="getDataList()">查询</el-button>
        <el-button v-if="isAuth('report:connection:save')" type="primary" @click="addOrUpdateHandle()">新增</el-button>
        <el-button v-if="isAuth('report:connection:delete')" type="danger" @click="deleteHandle()" :disabled="dataListSelections.length <= 0">批量删除</el-button>
      </el-form-item>
    </el-form>
    <el-table
      :data="dataList"
      border
      v-loading="dataListLoading"
      @selection-change="selectionChangeHandle"
      style="width: 100%;">
      <el-table-column
        type="selection"
        header-align="center"
        align="center"
        width="50">
      </el-table-column>
      <el-table-column
        prop="id"
        header-align="center"
        align="center"
        label="主键">
      </el-table-column>
      <el-table-column
        prop="name"
        header-align="center"
        align="center"
        label="链接名称">
      </el-table-column>
      <el-table-column
        header-align="center"
        align="center"
        label="连接测试">
        <template slot-scope="scope">
        <!-- <el-button type="primary" size="mini" @click=" $router.push({ name: 'demo-echarts' ,params: { userId: 123 }})">连接测试</el-button> -->
          <el-button type="primary" size="mini" @click="testConnect(scope.row.id)">连接测试</el-button>
          <!-- <el-tag v-if="scope.row.status === 0" size="small">正常</el-tag>
          <el-tag v-else size="small" type="danger">暂停</el-tag> -->
        </template>

      </el-table-column>

      <el-table-column
        prop="createDate"
        header-align="center"
        align="center"
     
        label="创建时间">
      </el-table-column>

      <!-- <el-table-column
        header-align="center"
        align="center"
        label="分配用户">
        <template slot-scope="scope"> -->
          <!-- <el-button type="primary" size="mini" @click="testConnect(scope.row.id)">分配角色</el-button> -->
          <!-- <el-tag v-if="scope.row.status === 0" size="small">正常</el-tag>
          <el-tag v-else size="small" type="danger">暂停</el-tag> -->

          <!-- <el-select v-model="value1" multiple  collapse-tags style="margin-left: 20px;" placeholder="请选择">
            <el-option
              v-for="item in roleList"
              :key="item.value"
              :label="item.label"
              :value="item.value">
            </el-option>
          </el-select>


        </template>

      </el-table-column> -->

      <!-- <el-table-column
        prop="driverName"
        header-align="center"
        align="center"
        label="驱动名">
      </el-table-column> -->
      <!-- <el-table-column
        prop="databaseName"
        header-align="center"
        align="center"
        label="数据库名">
      </el-table-column>
      <el-table-column
        prop="ip"
        header-align="center"
        align="center"
        label="主机ip">
      </el-table-column>
      <el-table-column
        prop="port"
        header-align="center"
        align="center"
        label="端口">
      </el-table-column>
      <el-table-column
        prop="userName"
        header-align="center"
        align="center"
        label="用户名">
      </el-table-column>
      <el-table-column
        prop="userPassword"
        header-align="center"
        align="center"
        label="密码">
      </el-table-column>
      <el-table-column
        prop="connectUrl"
        header-align="center"
        align="center"
        label="数据库链接的url">
      </el-table-column>
      <el-table-column
        prop="encode"
        header-align="center"
        align="center"
        label="编码方式">
      </el-table-column> -->
      <el-table-column
        fixed="right"
        header-align="center"
        align="center"
        width="150"
        label="操作">
        <template slot-scope="scope">
          <el-button type="text" size="small" @click="addOrUpdateHandle(scope.row.id)">修改</el-button>
          <el-button type="text" size="small" @click="deleteHandle(scope.row.id)">删除</el-button>
        </template>
      </el-table-column>
    </el-table>
    <el-pagination
      @size-change="sizeChangeHandle"
      @current-change="currentChangeHandle"
      :current-page="pageIndex"
      :page-sizes="[10, 20, 50, 100]"
      :page-size="pageSize"
      :total="totalPage"
      layout="total, sizes, prev, pager, next, jumper">
    </el-pagination>
    <!-- 弹窗, 新增 / 修改 -->
    <add-or-update v-if="addOrUpdateVisible" ref="addOrUpdate" @refreshDataList="getDataList"></add-or-update>
  </div>
</template>

<script>
  import AddOrUpdate from './connection-add-or-update'
  export default {
    data () {
      return {
         userList: [{
          value: '选项1',
          label: '黄金糕'
        }, {
          value: '选项2',
          label: '双皮奶'
        }, {
          value: '选项3',
          label: '蚵仔煎'
        }, {
          value: '选项4',
          label: '龙须面'
        }, {
          value: '选项5',
          label: '北京烤鸭'
        }],
        value1: [],
        value2: [],

        dataForm: {
          key: ''
        },
        dataList: [],
        pageIndex: 1,
        pageSize: 10,
        totalPage: 0,
        dataListLoading: false,
        dataListSelections: [],
        addOrUpdateVisible: false
      }
    },
    components: {
      AddOrUpdate
    },
    activated () {
      this.getDataList()
      this.getUsers()
    },
    methods: {
      //连接测试
      testConnect(id){
            this.$http({
              url: this.$http.adornUrl(`/report/connection/connect/${id}`),
              method: 'get',
              params: this.$http.adornParams()
            }).then(({data}) => {
              if (data && data.code === 0) {
                alert("连接成功!")
                // this.dataForm.name = data.connection.name
                // this.dataForm.createDate = data.connection.createDate
                // this.dataForm.driverName = data.connection.driverName
                // this.dataForm.databaseName = data.connection.databaseName
                // this.dataForm.ip = data.connection.ip
                // this.dataForm.port = data.connection.port
                // this.dataForm.userName = data.connection.userName
                // this.dataForm.userPassword = data.connection.userPassword
                // this.dataForm.connectUrl = data.connection.connectUrl
                // this.dataForm.encode = data.connection.encode
              }else{
                 alert("连接失败!")
              }
            })
      },

      getUsers(){
        this.$http({
          url: this.$http.adornUrl('/report/connection/users'),
          method: 'get',
          params: {}
        }).then(({data}) => {
            console.log(data)
            this.userList=data.userList;
        })
      },


      // 获取数据列表
      getDataList () {
        this.dataListLoading = true
        this.$http({
          url: this.$http.adornUrl('/report/connection/list'),
          method: 'get',
          params: this.$http.adornParams({
            'page': this.pageIndex,
            'limit': this.pageSize,
            'name': this.dataForm.name
          })
        }).then(({data}) => {
          if (data && data.code === 0) {
            this.dataList = data.page.list
            this.totalPage = data.page.totalCount
          } else {
            this.dataList = []
            this.totalPage = 0
          }
          this.dataListLoading = false
        })
      },
      // 每页数
      sizeChangeHandle (val) {
        this.pageSize = val
        this.pageIndex = 1
        this.getDataList()
      },
      // 当前页
      currentChangeHandle (val) {
        this.pageIndex = val
        this.getDataList()
      },
      // 多选
      selectionChangeHandle (val) {
        this.dataListSelections = val
      },
      // 新增 / 修改
      addOrUpdateHandle (id) {
        this.addOrUpdateVisible = true
        this.$nextTick(() => {
          this.$refs.addOrUpdate.init(id)
        })
      },
      // 删除
      deleteHandle (id) {
        var ids = id ? [id] : this.dataListSelections.map(item => {
          return item.id
        })
        this.$confirm(`确定对[id=${ids.join(',')}]进行[${id ? '删除' : '批量删除'}]操作?`, '提示', {
          confirmButtonText: '确定',
          cancelButtonText: '取消',
          type: 'warning'
        }).then(() => {
          this.$http({
            url: this.$http.adornUrl('/report/connection/delete'),
            method: 'post',
            data: this.$http.adornData(ids, false)
          }).then(({data}) => {
            if (data && data.code === 0) {
              this.$message({
                message: '操作成功',
                type: 'success',
                duration: 1500,
                onClose: () => {
                  this.getDataList()
                }
              })
            } else {
              this.$message.error(data.msg)
            }
          })
        })
      }
    }
  }
</script>
